Release 10.1A: OpenEdge Data Management:
SQL Reference

ATAN2

Returns the arctangent of the x and y coordinates specified by expression1 and expression2.

Syntax

ATAN2 ( expression1 , expression2 )

Example

The following example illustrates two ways to use the ATAN2 function:

select atan2 (1,1) * (180/ pi()) 'Arctangent in degrees' from syscalctable; ARCTANGENT IN DEGREES ----------------------- 45.000000000000000 1 record selected select atan2 (1,1) 'Arctangent in radians' from syscalctable; ARCTANGENT IN RADIANS ----------------------- 0.785398163397448 1 record selected

Notes

ATAN2 takes the ratio of two sides of a right triangle and returns the corresponding angle. The ratio is the length of the side opposite the angle divided by the length of the side adjacent to the angle.
expression1 and expression2 specify the x and y coordinates of the end of the hypotenuse opposite the angle.
The result is expressed in radians and is in the range -pi/2 to pi/2 radians. To convert degrees to radians, multiply degrees by pi/180. To convert radians to degrees, multiply radians by 180/pi.
Both expression1 and expression2 must evaluate to approximate numeric data types.

Compatibility

ODBC compatible